package database.dbtable;

/**
 * Created by alexander.makalov on 22.10.2014.
 */
public class MySqlClient {

    public static final String CLIENT_TABLE_NAME = "CLIENT";
    public static final String CLIENT_NAME = "name";
    public static final String CLIENT_SURNAME = "surname";
    public static final String CLIENT_PHONE = "phone";
    public static final String CLIENT_CITY = "city";
    public static final String CLIENT_DESCRIPTION = "description";
    public static final String CLIENT_ID = "id_client";

    public static final String CREATE_TABLE_QUERY_CLIENT =
            "create table IF NOT EXISTS "+CLIENT_TABLE_NAME+" ("
                    + CLIENT_ID +" bigint(20) not null primary key auto_increment, "
                    + CLIENT_NAME +" varchar(99) NOT NULL,"
                    + CLIENT_SURNAME + " varchar(99), "
                    + CLIENT_PHONE + " varchar(50), "
                    + CLIENT_CITY+" varchar(99), "
                    + CLIENT_DESCRIPTION+" LONGTEXT "+")";
}
